﻿CREATE TABLE [dbo].[zcjl] (
    [id]       INT             IDENTITY (1, 1) NOT FOR REPLICATION NOT NULL,
    [zcbh]     VARCHAR (50)    CONSTRAINT [DF_zcjl_zcjl] DEFAULT ('') NULL,
    [memo]     NVARCHAR (2000) CONSTRAINT [DF_Table_1_memo] DEFAULT ('') NULL,
    [lrrq]     DATETIME        CONSTRAINT [DF_zcjl_lrrq] DEFAULT (getdate()) NULL,
    [userid]   VARCHAR (30)    CONSTRAINT [DF_zcjl_userid] DEFAULT ('') NULL,
    [username] NVARCHAR (50)   CONSTRAINT [DF_zcjl_username] DEFAULT ('') NULL,
    CONSTRAINT [PK_zcjl] PRIMARY KEY CLUSTERED ([id] ASC)
);


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'资产编号', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'zcjl', @level2type = N'COLUMN', @level2name = N'zcbh';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'备注', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'zcjl', @level2type = N'COLUMN', @level2name = N'memo';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'录入日期', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'zcjl', @level2type = N'COLUMN', @level2name = N'lrrq';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'录入人编号', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'zcjl', @level2type = N'COLUMN', @level2name = N'userid';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'录入人姓名', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'zcjl', @level2type = N'COLUMN', @level2name = N'username';

